﻿CREATE PROCEDURE Search

AS

SELECT [Id]
      ,[FirstName]
      ,[Surname]
      ,[Age]
  FROM [Fluently].[dbo].[Person]
  
  
  SELECT COUNT(*) as NumberOfRows
  FROM [Fluently].[dbo].[Person]